﻿using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Drawing;
using System.Data;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace BKH.MyUserControl.UCHienThi
{
    public partial class ucDanhSachChoNhapVienTrongNgay : UserControl
    {
        public ucDanhSachChoNhapVienTrongNgay()
        {
            InitializeComponent();
            showNgayHienTai();
            showDanhSachChoNhapVienTrongNgay();
        }

        void showNgayHienTai()
        {
            lblNgayHienTai.Text = DateTime.Now.ToShortDateString();
        }

        void showDanhSachChoNhapVienTrongNgay()
        {
            //DateTime now = DateTime.Parse(DateTime.Now.ToShortDateString());
            //HospitalDBDataContext context = new HospitalDBDataContext();
            //var list = context.tbl_BenhNhanNoiTrus.Join(
            //    context.tbl_BenhNhan_LanKhams,
            //    a => a.LanKhamID,
            //    b => b.LanKhamID,
            //    (a, b) => new
            //    {
            //        BenhNhanID = b.BenhNhanID,
            //        BedID = a.BedID,
            //        Date_Start = a.Date_Start,
            //        Date_Finish = a.Date_Finish,
            //        Date_Wait = a.Date_Wait
            //    }
            //    ).Join(
            //    context.tbl_BenhNhans,
            //    c => c.BenhNhanID,
            //    d => d.BenhNhanID,
            //    (c, d) => new
            //    {

            //    }
            //    )

            //    .Where(n => DateTime.Compare((DateTime)n.Date_Start, now) == 0);
            //dataGridView1.DataSource = list;
        }
    }

 
}
